CREATE VIEW [dbo].[Login]
AS
SELECT     b.ContactID, a.FIRST_NAME AS FirstName, a.LAST_NAME AS LastName, a.EMAIL AS EmailAddress, a.COMPANY AS CompanyName,
                      a.DESIGNATION AS Title, b.WEB_LOGIN AS UserName, b.PASSWORD, NULL AS PasswordHint, a.ID AS BEMemberID, a.ID AS iMISMemberID,
                      CASE WHEN (b.EXPIRATION_DATE IS NOT NULL AND b.EXPIRATION_DATE < CURRENT_TIMESTAMP) OR
                      b.LOGIN_DISABLED = 1 THEN 'Y' ELSE 'N' END AS DisabledFlag, 0 AS NumLogin, NULL AS LastUpdateDateTime
FROM         dbo.Name AS a INNER JOIN
                      dbo.Name_Security AS b ON a.ID = b.ID INNER JOIN
                      dbo.Name_Fin AS c ON b.ID = c.ID
WHERE     (a.STATUS NOT LIKE 'D%')

GO